| Author |
Thread Statistics | Show CCP posts - 14 post(s) |
Hel O'Ween
Men On A Mission
EVE Trade Consortium
   |
Posted - 2011.08.30 20:30:00 -
[1]
Please, please do not release the data in CSV format. CSV has no strong data types nor is it locale aware. It's an ugly hack, the lowest common denominator ... from a couple of decades ago.
Anything is better than CSV. If you're looking for a text-based format, go for XML. 3rd party devs working with the (official) SDE already do have MSSQL installed somewhere. If not - pick up your free copy at MS's website.
--
EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
EVE Trade Consortium
|
Posted - 2011.08.31 18:30:00 -
[2]
 Originally by: Arkady Sadik
Parsing CSV (especially as this dump primarily contains numbers only, no complex strings) is trivial and fault-free in comparison.
Originally by: CCP Stillman
On the format discussion, I want to propose a suggestion. It might be silly, but hear me out:
CSV is a very simple format. I know that at least the database engine I work with on a daily basis(MSSQL), can import a CSV file into a table in about a small line of SQL. And I'd be surprised if other database engines couldn't.
Until you happen to use a locale where "CSV" is quite different. I work for an international company and have the "pleasure" to deal with exchanged CSV files. You know, in Germany in a "CSV" file, columns are actually delimited by ";" due to the fact that the comma is our decimal separator. Now try making sense out of a "real" CSV file.
As I said: for a text-based format almost anything is better than CSV.
--
EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
EVE Trade Consortium
|
Posted - 2011.09.01 10:50:00 -
[3]
Originally by: Monstress
You do know that databases that do support importing CSV files also support specifying custom delimiters, line endings, quotation and escape characters right?
Yes, I do know. But the typical user trying to open it in a spreadsheed not.
Bah, why do I still care at all?. My sub expires in December and that's it for me.
--
EVEWalletAware - an offline wallet manager |
| |
|